The lock modes in DB2 are used to determine whether one lock is compatible to another lock.
<> S Lock (Share): This mode allows the Lock owner and any concurrent process to read but not change the locked page or row.
<> U Lock (Update): This mode allows the Lock owner to read but not change the locked page. This lock mode reduces the chance of deadlocks.
<> X Lock (Exclusive): This mode allows the Lock owner to read or change the Locked page or row.
Posted Date:- 2021-09-03 08:48:51
Mention the way of highlighting as well as putting a CURSOR to use in a COBOL program.
Comment whether the cursor is closed during COMMIT or not.
Distinguish between segmented, simple, and partitioned tablespaces:
Explain correlated sub-queries.
What is the information associated with SYSIBM.SYSLINKS table?
How can tablespace be moved to another DASD volume that is allocated for that tablespace?
Explain the Function done by data manager?
What do you mean by a recovery log?
Distinguish between segmented, simple, and partitioned tablespaces:
Describe the four environments that access DB2:
Define the value function purpose:
What does the buffer manager do?
What is meant by SQL Communication Area?
What does Data Warehousing use?
What Does Dsndb07 Database Do?
What Is Declaration Generator(dclgen)?
What Is A Database Request Module(dbrm)?
What Is The Function Of The Data Manager?
What Will The Commit Accomplish?
On The Create Tablespace, What Does The Close Parameter Do?
How Many Buffer Pools Are There In Db2?
Explain various types of Locks in DB2?
What are the full forms of SPUFI and DCLGEN and why are they used?
Give a brief description of DB2 Isolation Levels?
What is meant by the attachment facility?
What information is used as input to the binding process?
Describe major components of DB2?
Explain PACKAGE in DB2 and its advantages?
What is Buffer pool and list some of them?